Records in subform but do not move due to 'Link' properties not set.
Cause:
The 'Link Child Fields' and 'Link Master Fields' properties are not assigned in the property sheet.
Solution:
In the Form Design view, use the 'Link Child Fields' and 'Link Master Fields' property boxes in the property sheet of the selected subform to link to the main form.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired main form which also contains the subform from the list. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Properties'. (The property sheet appears.)
6) Position the mouse pointer on the subform.
7) Click on the subform. (Handles appear around the subform.)
8) Click the 'Data' tab in the property sheet.
9) Click on the 'Link Child Fields' box. (A blinking cursor appears.)
10) Type the desired field name to link the subform to the main form.
11) Click on the 'Link Master Fields' box. (A blinking cursor appears.)
12) Type the desired field name to link the main form to the subform.
13) Select the 'File' menu and select 'Save' to save changes to the form.